Students will learn basic worksheets skills and how to work with data in worksheets.
Lesson 1:Getting Started
Spreadsheet terminology
The Excel window
Getting help
Navigating workbooks
Lesson 2: Creating a worksheet
Entering and editing text and values
Entering and editing formulas
Working with pictures
Saving and updating workbooks
Lesson 3: Modifying a worksheet
Moving and copying data
Moving and copying formulas
Absolute and relative references
Inserting and deleting ranges, rows and columns
Lesson 4: Using functions
Entering functions
AutoSum
Other functions
Lesson 5: Formatting worksheets
Formatting text
Formatting rows and columns
Formatting numbers
Conditional formatting
Additional formatting options
Lesson 6: Printing
Preparing to print
Page Setup options
Printing worksheets
Lesson 7: Creating Charts
Chart basics
Formatting charts
Computers for Beginners
or equivalent knowledge.
7.5 hours
Distance Learning price | ||
For other prices, please contact us.
Click here to see all our courses.
|
|